Oracle Database 11g: Administration II - Exam Number 1Z0-053

Database Architecture and ASM

• Describe Automatic Storage Management (ASM).
• Set up initialization parameter files for ASM and database instances .
• Start up and shut down ASM instances .
• Administer ASM disk groups.

Configuring for Recoverability

• Configure multiple archive log file destinations to increase availability.
• Define, apply and use a retention policy .
• Configure the Flash Recovery Area .
• Use Flash Recovery Area.

Using the RMAN Recovery Catalog

• Identify situations that require RMAN recovery catalog.
• Create and configure a recovery catalog .
• Synchronize the recovery catalog .
• Create and Use RMAN stored scripts .
• Back up the recovery catalog .
• Create and use a virtual private catalog.

Configuring Backup Specifications

• Configure backup settings.
• Allocate channels to use in backing up.
• Configure backup optimization.

Using RMAN to Create Backups

• Create image file backups.
• Create a whole database backup
• Enable fast incremental backup
• Create duplex backup and back up backup sets.
• Create an archival backup for long-term retention.
• Create a multisection, compressed and encrypted backup .
• Report on and maintain backups.

Performing User-Managed Backup and Recovery

• Recover from a lost TEMP file.
• Recover from a lost redo log group.
• Recover from the loss of password file.
• Perform user-managed complete database recovery .
• Perform user-managed incomplete database recovery.
• Perform user-managed and server managed backups.
• Identify the need of backup mode .
• Back up and recover a control file .

Using RMAN to Perform Recovery

• Perform complete recovery from a critical or noncritical data file loss using RMAN.
• Perform incomplete recovery using RMAN .
• Recover using incrementally updated backups.
• Switch to image copies for fast recovery .
• Restore a database onto a new host.
• Recover using a backup control file.
• Perform Disaster recovery.

Using RMAN to Duplicate a Database

• Creating a duplicate database
• Using a duplicate database

Performing Tablespace Point-in-Time Recovery

• Identify the situations that require TSPITR
• Perform automated TSPITR.

Monitoring and Tuning RMAN

• Monitoring RMAN sessions and jobs.
• Tuning RMAN .
• Configure RMAN for Asynchronous I/O.

Using Flashback Technology

• Restore dropped tables from the recycle bin.
• Perform Flashback Query.
• Use Flashback Transaction.
• Manage Alerts and Thresholds.

Additional Flashback Operations

• Perform Flashback Table operations.
• Configure, Monitor Flashback Database and Perform Flashback Database operations .
• Set up and use a Flashback Data Archive.

Diagnosing the Database

• Set up Automatic Diagnostic Repository.
• Using Support Workbench.
• Perform Block Media Recovery.

Managing Memory

• Implement Automatic Memory Management.
• Manually configure SGA parameters.
• Configure automatic PGA memory management.

Managing Database Performance

• Use the SQL Tuning Advisor.
• Use the SQL Access Advisor to tune a workload.
• Understand Database Replay.

Space Management

• Manage resumable space allocation.
• Describe the concepts of transportable tablespaces and databases .
• Reclaim wasted space from tables and indexes by using the segment shrink functionality.

Managing Resources

• Understand the database resource manager.
• Create and use Database Resource Manager Components.

Automating Tasks with the Scheduler

• Create a job, program, and schedule.
• Use a time-based or event-based schedule for executing Scheduler jobs .
• Create lightweight jobs .
• Use job chains to perform a series of related tasks .

Administering the Scheduler

• Create Windows and Job Classes.
• Use advanced Scheduler concepts to prioritize jobs.